﻿<?xml version="1.0"?>
<CsvDataLoaderParams xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <TableMetadataEntity>
    <Name>Completed Construction Projects 2005</Name>
    <Category>Infrastructure</Category>
    <Description>This dataset contains attributes of construction projects completed by the DC Department of Transportation in 2005</Description>
    <Source>District Department of Transportation</Source>
    <LastUpdateDate>2006-01-01T00:00:00</LastUpdateDate>
    <MetadataUrl>http://data.octo.dc.gov/Metadata.aspx?id=16</MetadataUrl>
    <EntitySet>CompletedConstructionProjects2005</EntitySet>
    <EntityKind>CompletedConstructionProject2005</EntityKind>
  </TableMetadataEntity>
  <ProducerParams>
    <PlacemarkParams>
      <LatitudeProperty>LATITUDE</LatitudeProperty>
      <LongitudeProperty>LONGITUDE</LongitudeProperty>
      <NamePropertyFormatString>Street: {0} {1} Work: {2} Completed: {3}</NamePropertyFormatString>
      <NameProperties>
        <string>STREET</string>
        <string>QUADRANT</string>
        <string>WORKDESCRIPTION</string>
        <string>ACTUALCOMPLETIONDATE</string>
      </NameProperties>
    </PlacemarkParams>
    <PropertyToTypeMap>
      <STREET>string</STREET>
      <QUADRANT>string</QUADRANT>
      <FROMINTERSECTION>string</FROMINTERSECTION>
      <TOINTERSECTION>string</TOINTERSECTION>
      <NOOFBLOCKS>Int32</NOOFBLOCKS>
      <WORKDESCRIPTION>string</WORKDESCRIPTION>
      <YEARBUDGETED>Int32</YEARBUDGETED>
      <PERCENTCOMPLETED>double</PERCENTCOMPLETED>
      <STATUS>string</STATUS>
      <MILES>double</MILES>
      <WARD>string</WARD>
      <FUNCTIONALCLASS>string</FUNCTIONALCLASS>
      <ESTIMATEDSTARTDATE>DateTime</ESTIMATEDSTARTDATE>
      <ESTIMATEDCOMPLETIONDATE>DateTime</ESTIMATEDCOMPLETIONDATE>
      <ACTUALCOMPLETIONDATE>DateTime</ACTUALCOMPLETIONDATE>
      <REMARKS>string</REMARKS>
      <XCOORD>double</XCOORD>
      <YCOORD>double</YCOORD>
      <LATITUDE>double</LATITUDE>
      <LONGITUDE>double</LONGITUDE>
      <PROJECTNOTE>string</PROJECTNOTE>
      <PROJECTNAME>string</PROJECTNAME>
      <PROJECTMGR>string</PROJECTMGR>
      <PROJECTID>string</PROJECTID>
      <TEAMREP>string</TEAMREP>
      <EMAIL>string</EMAIL>
      <CONTACTPHONE>string</CONTACTPHONE>
    </PropertyToTypeMap>
  </ProducerParams>
  <ProcessorParams>
    <PartitionKeyPropertyName>STREET</PartitionKeyPropertyName>
    <RowKeyPropertyName>New.Guid</RowKeyPropertyName>
    <TableMetadataPartitionKeyPropertyName>Name</TableMetadataPartitionKeyPropertyName>
    <TableMetadataRowKeyPropertyName>New.Guid</TableMetadataRowKeyPropertyName>
    <EntityMetadataPartitionKeyPropertyName>EntitySet</EntityMetadataPartitionKeyPropertyName>
    <EntityMetadataRowKeyPropertyName>EntityKind</EntityMetadataRowKeyPropertyName>
  </ProcessorParams>
</CsvDataLoaderParams>